from django.db import models


# Create your models here.

class BaseData(models.Model):
    cmd = models.CharField(verbose_name='命令', max_length=256,null=True,blank=True)
    type = models.CharField(verbose_name='类型',max_length=32,null=True,blank=True)
    data_result = models.CharField(verbose_name='data结论',max_length=32,null=True,blank=True)
    sql_result = models.CharField(verbose_name='sql结论',max_length=32,null=True,blank=True)
    result = models.CharField(verbose_name='一键审核结论',max_length=32,null=True,blank=True)
    manual_result = models.CharField(verbose_name='人工复审结论',max_length=32,null=True,blank=True)
    comment = models.CharField(verbose_name='备注',max_length=32,null=True,blank=True)
    create_time = models.DateTimeField(verbose_name='创建时间',auto_now_add=True,null=True)

class CompareData(models.Model):
    cmd = models.ForeignKey(verbose_name='命令', max_length=256,to='BaseData')
    recv_type = models.CharField(verbose_name='邮箱', max_length=32,null=True,blank=True)
    recv_chart = models.CharField(verbose_name='图表类型',max_length=32,null=True,blank=True)
    recv_tts = models.CharField(verbose_name='tts',max_length=1280,null=True,blank=True)
    recv_sql = models.CharField(verbose_name='sql',max_length=5120,null=True,blank=True)
    recv_data = models.CharField(verbose_name='data',max_length=5120,null=True,blank=True)
    create_time = models.DateTimeField(verbose_name='创建时间', auto_now_add=True, null=True)
    version = models.CharField(verbose_name='版本',max_length=32,null=True,blank=True)
